﻿SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[bhp_ASyncMailStockSave]
	@TemplateId		INT,
	@Object			NVARCHAR(MAX),
	@Type			NVARCHAR(400),
	@ReceiverMail	NVARCHAR(200),
	@ReceiverDisplayName	NVARCHAR(200),
	@Receiver		NVARCHAR(100),
	@MessageTitle	NVARCHAR(400)
AS
BEGIN

	SET NOCOUNT ON;
	
	INSERT INTO bht_ASyncMailStock (TemplateId, [Object], [Type], ReceiverMail, ReceiverDisplayName, MessageTitle)
		VALUES (@TemplateId, @Object, @Type, @ReceiverMail, @ReceiverDisplayName, @MessageTitle)
		
	SELECT SCOPE_IDENTITY() as RequestId

END